` _kbjih⌘⇧⌥⌃a !"#$%&'()*+,-./01gf2345e6789:;<=>?@ABCDEFGHdcIJKL Year (date) WordCount (text) WeekofYearFiscal (date, starting day) WeekofYear (date) ValueListNames (dbname) ValueListItems (dbname, valuelist) Upper (text) Truncate (number, precision) Trim (text) Today TimeToText (time) Time (hours, minutes, seconds) TextToTime (text) TextToNum (text) TextToDate (text) Tan (number) Sum (field…) Substitute (text, search string, replace string) StDevP (field…) StDev (field…) Status (status flag) Sqrt (number) Sin (number) Sign (number) Seconds (time) ScriptNames (dbname) Round (number, precision) RightWords (text, number of words) Right (text, number) Replace (text, start, size, replacement text) RelationNames (dbname) RelationInfo (dbname, relationname) Random Radians (number) PV (payment, interest rate, periods) Proper (text) Position (text, search string, start, occurrence) PMT (principal, interest rate, term) PI PatternCount (text, search string) NumToText (number) NPV (payment, interest rate) MonthName (date) Month (date) Mod (number, divisor) Minute (time) Min (field…) MiddleWords (text, starting word, number of words) Middle (text, start, size) Max (field…) Lower (text) Log (number) Ln (number) Length (text) LeftWords (text, number of words) Left (text, number) LayoutNames (dbname) Last (repeating field) IsValid (field) IsEmpty (field) Int (number) If (test, result one, result two) Hour (time) GetSummary (summary field, break field) GetRepetition (repeating field, number) FV (payment, interest rate, periods) FieldType (dbname, fieldname) FieldStyle (dbname, layoutname, fieldname) FieldRepetitions (dbname, layoutname, fieldname) FieldNames (dbname, layoutname) FieldBounds (dbname, layoutname, fieldname) External (name, parameter) Extend (non-repeating field) Exp (number) Exact (original text, comparison text) Degrees (number) DayofYear (date) DayofWeek (date) DayName (date) Day (date) DateToText (date) Date (month, day, year) DatabaseNames Count (field…) Cos (number) Choose (test, result0 [, result1, result2]…) Case (test1, result1 [, test2, result2, default result]…) Average (field…) Atan (number) Abs (number)